Tables [dbo].[RFMDefinition_Detail]
Properties
PropertyValue
Created3:13:16 PM Friday, January 07, 2011
Last Modified11:40:07 AM Monday, February 20, 2012
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key PK_RFMDefinition_Detail: RFMKey\TypeRFMKeyuniqueidentifier16
No
Cluster Primary Key PK_RFMDefinition_Detail: RFMKey\TypeTypechar(10)10
No
Rankingchar(10)10
Yes
Valuechar(20)20
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK_RFMDefinition_Detail: RFMKey\TypePK_RFMDefinition_DetailRFMKey, Type
Yes
SQL Script
CREATE TABLE [dbo].[RFMDefinition_Detail]
(
[RFMKey] [uniqueidentifier] NOT NULL,
[Type] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Ranking] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Value] [char] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[RFMDefinition_Detail] ADD CONSTRAINT [PK_RFMDefinition_Detail] PRIMARY KEY CLUSTERED ([RFMKey], [Type]) ON [PRIMARY]
GO
Uses